Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1060
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	124.3 KiB
Average record size in memory	120.1 B

Variable types

NUM	13
CAT	2

Warnings

`Importers` has a high cardinality: 225 distinct values	High cardinality
`Exported value in 2010` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2009` is highly correlated with `Exported value in 2010` and 10 other fields	High correlation
`Exported value in 2011` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2012` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2013` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2014` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2015` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2016` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2017` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2018` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2019` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Exported value in 2020` is highly correlated with `Exported value in 2009` and 10 other fields	High correlation
`Importers` is uniformly distributed	Uniform
`df_index` has unique values	Unique

Reproduction

Analysis started	2021-12-08 15:17:35.783733
Analysis finished	2021-12-08 15:17:58.610442
Duration	22.83 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	1060
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	651.9066038
Minimum	0
Maximum	1284
Zeros	1
Zeros (%)	0.1%
Memory size	8.3 KiB

Quantile statistics

Minimum	0
5-th percentile	52.95
Q1	331.75
median	616.5
Q3	992.25
95-th percentile	1231.05
Maximum	1284
Range	1284
Interquartile range (IQR)	660.5

Descriptive statistics

Standard deviation	380.9594688
Coefficient of variation (CV)	0.5843773734
Kurtosis	-1.241893638
Mean	651.9066038
Median Absolute Deviation (MAD)	330.5
Skewness	0.01041436393
Sum	691021
Variance	145130.1169
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1284	1	0.1%
428	1	0.1%
442	1	0.1%
441	1	0.1%
440	1	0.1%
439	1	0.1%
438	1	0.1%
437	1	0.1%
436	1	0.1%
435	1	0.1%
Other values (1050)	1050	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
1284	1	0.1%
1283	1	0.1%
1282	1	0.1%
1281	1	0.1%
1280	1	0.1%

Importers
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	225
Distinct (%)	21.2%
Missing	0
Missing (%)	0.0%
Memory size	8.3 KiB

Antigua and Barbuda	6
Italy	6
Morocco	6
World	6
Côte d'Ivoire	6
Other values (220)	1030

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Antigua and Barbuda	6	0.6%
Italy	6	0.6%
Morocco	6	0.6%
World	6	0.6%
Côte d'Ivoire	6	0.6%
Switzerland	6	0.6%
Austria	6	0.6%
Malta	6	0.6%
Norway	6	0.6%
Mali	6	0.6%
Other values (215)	1000	94.3%

Frequencies of value counts

Unique

Unique	10 ?
Unique (%)	0.9%

Histogram of lengths of the category

Length

Max length	41
Median length	8
Mean length	10.22169811
Min length	4

Exported value in 2009
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1050
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6675962.512
Minimum	4
Maximum	1201646800
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	4
5-th percentile	287.8
Q1	12625.25
median	129507.5
Q3	1057099.25
95-th percentile	16513256.1
Maximum	1201646800
Range	1201646796
Interquartile range (IQR)	1044474

Descriptive statistics

Standard deviation	61683711.05
Coefficient of variation (CV)	9.239673071
Kurtosis	313.7285427
Mean	6675962.512
Median Absolute Deviation (MAD)	128655.5
Skewness	17.31223806
Sum	7076520263
Variance	3.804880209e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	2	0.2%
152	2	0.2%
35	2	0.2%
264	2	0.2%
592	2	0.2%
40	2	0.2%
1047	2	0.2%
65	2	0.2%
57	2	0.2%
408	2	0.2%
Other values (1040)	1040	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	0.1%
9	1	0.1%
12	2	0.2%
16	1	0.1%
18	1	0.1%

Value	Count	Frequency (%)
1201646800	1	0.1%
1125844048	1	0.1%
1056712100	1	0.1%
221295020	1	0.1%
204720827	1	0.1%

Exported value in 2010
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1049
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8116408.25
Minimum	2
Maximum	1577763800
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	2
5-th percentile	245.75
Q1	12428
median	142247
Q3	1273150.25
95-th percentile	21685151.95
Maximum	1577763800
Range	1577763798
Interquartile range (IQR)	1260722.25

Descriptive statistics

Standard deviation	75476927.83
Coefficient of variation (CV)	9.299301551
Kurtosis	324.771849
Mean	8116408.25
Median Absolute Deviation (MAD)	141445
Skewness	17.5364744
Sum	8603392745
Variance	5.696766634e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	4	0.4%
35	2	0.2%
11	2	0.2%
19	2	0.2%
54	2	0.2%
2	2	0.2%
10	2	0.2%
295	2	0.2%
98	2	0.2%
1201450	1	0.1%
Other values (1039)	1039	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2	0.2%
5	1	0.1%
7	1	0.1%
9	4	0.4%
10	2	0.2%

Value	Count	Frequency (%)
1577763800	1	0.1%
1278099187	1	0.1%
1267743109	1	0.1%
283780323	1	0.1%
249248666	1	0.1%

Exported value in 2011
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1056
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9574936.437
Minimum	2
Maximum	1898388400
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	2
5-th percentile	398.1
Q1	17328
median	173469.5
Q3	1487219
95-th percentile	25973965.7
Maximum	1898388400
Range	1898388398
Interquartile range (IQR)	1469891

Descriptive statistics

Standard deviation	89141914.67
Coefficient of variation (CV)	9.309922343
Kurtosis	330.4217695
Mean	9574936.437
Median Absolute Deviation (MAD)	172502.5
Skewness	17.65817487
Sum	1.014943262e+10
Variance	7.946280951e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3957	2	0.2%
51	2	0.2%
65	2	0.2%
18084	2	0.2%
355663	1	0.1%
214104	1	0.1%
4833	1	0.1%
8256768	1	0.1%
43461394	1	0.1%
94803	1	0.1%
Other values (1046)	1046	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.1%
3	1	0.1%
9	1	0.1%
12	1	0.1%
17	1	0.1%

Value	Count	Frequency (%)
1898388400	1	0.1%
1483802558	1	0.1%
1481682200	1	0.1%
325010988	1	0.1%
281237169	1	0.1%

Exported value in 2012
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1052
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9864321.009
Minimum	1
Maximum	2048782200
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	377.85
Q1	19195
median	191108.5
Q3	1566278
95-th percentile	27112573.9
Maximum	2048782200
Range	2048782199
Interquartile range (IQR)	1547083

Descriptive statistics

Standard deviation	92431719.45
Coefficient of variation (CV)	9.370307329
Kurtosis	344.5279265
Mean	9864321.009
Median Absolute Deviation (MAD)	189854
Skewness	17.91591967
Sum	1.045618027e+10
Variance	8.54362276e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52512	2	0.2%
2776	2	0.2%
348	2	0.2%
593	2	0.2%
1627	2	0.2%
213	2	0.2%
1585	2	0.2%
1	2	0.2%
120480	1	0.1%
18773079	1	0.1%
Other values (1042)	1042	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.2%
5	1	0.1%
9	1	0.1%
11	1	0.1%
12	1	0.1%

Value	Count	Frequency (%)
2048782200	1	0.1%
1544932000	1	0.1%
1410146321	1	0.1%
352438221	1	0.1%
323445330	1	0.1%

Exported value in 2013
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1058
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10316237.17
Minimum	2
Maximum	2209007300
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	2
5-th percentile	587.15
Q1	19216.25
median	201862
Q3	1690360.5
95-th percentile	26966530.95
Maximum	2209007300
Range	2209007298
Interquartile range (IQR)	1671144.25

Descriptive statistics

Standard deviation	97257525.11
Coefficient of variation (CV)	9.427616241
Kurtosis	355.291795
Mean	10316237.17
Median Absolute Deviation (MAD)	200419.5
Skewness	18.11601874
Sum	1.09352114e+10
Variance	9.45902619e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1884	2	0.2%
156	2	0.2%
26110918	1	0.1%
300361	1	0.1%
5928	1	0.1%
3755649	1	0.1%
759	1	0.1%
731790	1	0.1%
120402	1	0.1%
4833	1	0.1%
Other values (1048)	1048	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.1%
10	1	0.1%
12	1	0.1%
16	1	0.1%
18	1	0.1%

Value	Count	Frequency (%)
2209007300	1	0.1%
1577587300	1	0.1%
1450937515	1	0.1%
384497867	1	0.1%
369063859	1	0.1%

Exported value in 2014
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1053
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10734126.11
Minimum	1
Maximum	2342292696
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	489.8
Q1	19403.75
median	184508.5
Q3	1720203.5
95-th percentile	28409855.15
Maximum	2342292696
Range	2342292695
Interquartile range (IQR)	1700799.75

Descriptive statistics

Standard deviation	101581320.1
Coefficient of variation (CV)	9.463399167
Kurtosis	364.4566952
Mean	10734126.11
Median Absolute Deviation (MAD)	183532.5
Skewness	18.31188308
Sum	1.137817368e+10
Variance	1.031876459e+16
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1239	2	0.2%
1453	2	0.2%
169	2	0.2%
558	2	0.2%
32	2	0.2%
147	2	0.2%
416	2	0.2%
175762	1	0.1%
6886149	1	0.1%
11642828	1	0.1%
Other values (1043)	1043	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
4	1	0.1%
6	1	0.1%
14	1	0.1%
19	1	0.1%

Value	Count	Frequency (%)
2342292696	1	0.1%
1619742900	1	0.1%
1498238432	1	0.1%
397099250	1	0.1%
363077144	1	0.1%

Exported value in 2015
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1053
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10013341.84
Minimum	1
Maximum	2281855922
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	577.95
Q1	18539.75
median	167101
Q3	1413758.25
95-th percentile	25869347.35
Maximum	2281855922
Range	2281855921
Interquartile range (IQR)	1395218.5

Descriptive statistics

Standard deviation	95899120.56
Coefficient of variation (CV)	9.577134398
Kurtosis	385.8842506
Mean	10013341.84
Median Absolute Deviation (MAD)	166003
Skewness	18.73417406
Sum	1.061414235e+10
Variance	9.196641325e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
640	2	0.2%
28	2	0.2%
39	2	0.2%
1119	2	0.2%
1358	2	0.2%
85	2	0.2%
426	2	0.2%
10376	1	0.1%
160996	1	0.1%
18208	1	0.1%
Other values (1043)	1043	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
5	1	0.1%
9	1	0.1%
13	1	0.1%
16	1	0.1%

Value	Count	Frequency (%)
2281855922	1	0.1%
1503328350	1	0.1%
1323665116	1	0.1%
410804880	1	0.1%
334290810	1	0.1%

Exported value in 2016
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1056
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9623326.882
Minimum	3
Maximum	2118980582
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	3
5-th percentile	547.65
Q1	18022
median	162727.5
Q3	1310669.5
95-th percentile	25232693.9
Maximum	2118980582
Range	2118980579
Interquartile range (IQR)	1292647.5

Descriptive statistics

Standard deviation	91343905.96
Coefficient of variation (CV)	9.49192593
Kurtosis	368.2459031
Mean	9623326.882
Median Absolute Deviation (MAD)	161689
Skewness	18.38824763
Sum	1.02007265e+10
Variance	8.343709157e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
225	2	0.2%
635	2	0.2%
665	2	0.2%
187	2	0.2%
73792	1	0.1%
515388	1	0.1%
21647178	1	0.1%
9938902	1	0.1%
58536	1	0.1%
2548	1	0.1%
Other values (1046)	1046	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	0.1%
14	1	0.1%
18	1	0.1%
31	1	0.1%
33	1	0.1%

Value	Count	Frequency (%)
2118980582	1	0.1%
1451459684	1	0.1%
1332489067	1	0.1%
388145454	1	0.1%
292214997	1	0.1%

Exported value in 2017
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1055
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10333039.06
Minimum	1
Maximum	2271796142
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	491.75
Q1	19949
median	166461
Q3	1420995.5
95-th percentile	28853826.65
Maximum	2271796142
Range	2271796141
Interquartile range (IQR)	1401046.5

Descriptive statistics

Standard deviation	98001280.72
Coefficient of variation (CV)	9.484265006
Kurtosis	367.7734305
Mean	10333039.06
Median Absolute Deviation (MAD)	165638
Skewness	18.38310885
Sum	1.09530214e+10
Variance	9.604251023e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	2	0.2%
243	2	0.2%
1423	2	0.2%
1464	2	0.2%
301	2	0.2%
33706	1	0.1%
1340709	1	0.1%
66050	1	0.1%
1426728	1	0.1%
9054612	1	0.1%
Other values (1045)	1045	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
4	1	0.1%
5	1	0.1%
7	1	0.1%
15	1	0.1%

Value	Count	Frequency (%)
2271796142	1	0.1%
1547195403	1	0.1%
1444776367	1	0.1%
431664273	1	0.1%
282773830	1	0.1%

Exported value in 2018
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1056
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11215782.84
Minimum	3
Maximum	2494230195
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	3
5-th percentile	467.75
Q1	17696
median	192151.5
Q3	1584339
95-th percentile	30970190.9
Maximum	2494230195
Range	2494230192
Interquartile range (IQR)	1566643

Descriptive statistics

Standard deviation	106632195.7
Coefficient of variation (CV)	9.507334194
Kurtosis	373.6366908
Mean	11215782.84
Median Absolute Deviation (MAD)	190923.5
Skewness	18.50349698
Sum	1.188872981e+10
Variance	1.137042517e+16
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
297694	2	0.2%
1253	2	0.2%
102	2	0.2%
2082	2	0.2%
768789	1	0.1%
467202	1	0.1%
6542161	1	0.1%
3590574	1	0.1%
157851	1	0.1%
4821886	1	0.1%
Other values (1046)	1046	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	0.1%
15	1	0.1%
16	1	0.1%
17	1	0.1%
20	1	0.1%

Value	Count	Frequency (%)
2494230195	1	0.1%
1665688484	1	0.1%
1556622939	1	0.1%
479701581	1	0.1%
302960301	1	0.1%

Exported value in 2019
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1056
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11083445.68
Minimum	1
Maximum	2498569866
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	430.35
Q1	19956
median	194883
Q3	1645558
95-th percentile	31194244.95
Maximum	2498569866
Range	2498569865
Interquartile range (IQR)	1625602

Descriptive statistics

Standard deviation	105119639.5
Coefficient of variation (CV)	9.484382617
Kurtosis	387.131064
Mean	11083445.68
Median Absolute Deviation (MAD)	193880.5
Skewness	18.80743654
Sum	1.174845242e+10
Variance	1.105013861e+16
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1280	2	0.2%
67	2	0.2%
1698	2	0.2%
2133	2	0.2%
6217845	1	0.1%
270592	1	0.1%
44957	1	0.1%
17321763	1	0.1%
450878	1	0.1%
5781	1	0.1%
Other values (1046)	1046	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
4	1	0.1%
6	1	0.1%
13	1	0.1%
24	1	0.1%

Value	Count	Frequency (%)
2498569866	1	0.1%
1642820352	1	0.1%
1486877250	1	0.1%
418584250	1	0.1%
292820258	1	0.1%

Exported value in 2020
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1055
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10601905.12
Minimum	1
Maximum	2590607686
Zeros	0
Zeros (%)	0.0%
Memory size	8.3 KiB

Quantile statistics

Minimum	1
5-th percentile	265.95
Q1	16528
median	159674.5
Q3	1452517.25
95-th percentile	27594597.65
Maximum	2590607686
Range	2590607685
Interquartile range (IQR)	1435989.25

Descriptive statistics

Standard deviation	102711902.5
Coefficient of variation (CV)	9.688060896
Kurtosis	439.4562908
Mean	10601905.12
Median Absolute Deviation (MAD)	158989.5
Skewness	19.82194003
Sum	1.123801943e+10
Variance	1.054973491e+16
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
101	3	0.3%
1	2	0.2%
156	2	0.2%
125	2	0.2%
51113	1	0.1%
1715	1	0.1%
441134	1	0.1%
259746	1	0.1%
709257	1	0.1%
5084253	1	0.1%
Other values (1045)	1045	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.2%
7	1	0.1%
14	1	0.1%
18	1	0.1%
21	1	0.1%

Value	Count	Frequency (%)
2590607686	1	0.1%
1424934919	1	0.1%
1378030840	1	0.1%
452576771	1	0.1%
272658016	1	0.1%

Exporter
Categorical

Distinct	6
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	8.3 KiB

USA	216
Germany	212
China	208
Turkey	200
Argentina	132

Frequencies
Length

Value	Count	Frequency (%)
USA	216	20.4%
Germany	212	20.0%
China	208	19.6%
Turkey	200	18.9%
Argentina	132	12.5%
Senegal	92	8.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	6
Mean length	5.852830189
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	Importers	Exported value in 2009	Exported value in 2010	Exported value in 2011	Exported value in 2012	Exported value in 2013	Exported value in 2014	Exported value in 2015	Exported value in 2016	Exported value in 2017	Exported value in 2018	Exported value in 2019	Exported value in 2020	Exporter
0	0	World	55672119.0	68174447.0	82981091.0	79982380.0	75962981.0	68404347.0	56752410.0	57733363.0	58133543.0	61781529.0	65115327.0	54821594.0	Argentina
1	1	Area Nes	920693.0	1264426.0	1834964.0	2122119.0	2169320.0	1877791.0	986638.0	687730.0	861872.0	13540999.0	13274880.0	19296159.0	Argentina
2	2	Brazil	11379426.0	14432985.0	17317105.0	16456672.0	15948973.0	13882695.0	10081115.0	9027619.0	9298290.0	8169488.0	7606172.0	5084253.0	Argentina
3	3	China	3666461.0	5798858.0	6033117.0	5068296.0	5511588.0	4459978.0	5174432.0	4425230.0	4319031.0	3847265.0	6325086.0	4594625.0	Argentina
4	4	Viet Nam	547244.0	655730.0	680395.0	800856.0	1185117.0	1550427.0	1801363.0	2546073.0	2271503.0	2071323.0	2749346.0	2746244.0	Argentina
5	5	Chile	4386659.0	4493083.0	4772318.0	5051834.0	3823118.0	2792208.0	2398278.0	2297397.0	2597656.0	2620758.0	2670597.0	2226775.0	Argentina
6	6	India	648331.0	1321491.0	968773.0	1186810.0	1089096.0	1810469.0	2003132.0	2208521.0	2080801.0	1474973.0	1843917.0	2118078.0	Argentina
7	7	United States of America	3680361.0	3668828.0	4301136.0	4023111.0	4182358.0	4081824.0	3422832.0	4482604.0	4460272.0	2886601.0	2875505.0	1529417.0	Argentina
8	8	Indonesia	603956.0	852442.0	1366929.0	1549439.0	1469194.0	1239639.0	1079289.0	1243438.0	1073249.0	1220882.0	1579219.0	1262827.0	Argentina
9	9	Netherlands	2392143.0	2369770.0	2548736.0	2204215.0	1912958.0	1574556.0	1205855.0	1170977.0	1374942.0	1523674.0	1606701.0	1209206.0	Argentina

Last rows

	df_index	Importers	Exported value in 2009	Exported value in 2010	Exported value in 2011	Exported value in 2012	Exported value in 2013	Exported value in 2014	Exported value in 2015	Exported value in 2016	Exported value in 2017	Exported value in 2018	Exported value in 2019	Exported value in 2020	Exporter
1050	1275	Comoros	1931.0	1259.0	1095.0	954.0	3491.0	3453.0	1507.0	1350.0	1375.0	2778.0	1513.0	1411.0	USA
1051	1276	French Southern and Antarctic Territories	959.0	589.0	1426.0	1239.0	1750.0	8252.0	8027.0	4912.0	2843.0	818.0	6805.0	882.0	USA
1052	1277	Sao Tome and Principe	4018.0	1359.0	6124.0	870.0	1998.0	1088.0	854.0	1994.0	3141.0	2068.0	2697.0	733.0	USA
1053	1278	Nauru	3687.0	2492.0	499.0	2209.0	759.0	812.0	1734.0	495.0	199.0	797.0	1232.0	607.0	USA
1054	1279	Falkland Islands (Malvinas)	2356.0	2718.0	3957.0	4347.0	1241.0	7846.0	2918.0	1485.0	482.0	215.0	318.0	306.0	USA
1055	1280	St. Pierre and Miquelon	215.0	15.0	119.0	180.0	262.0	4.0	227.0	62.0	391.0	132.0	88.0	272.0	USA
1056	1281	Niue	1210.0	1571.0	716.0	772.0	249.0	112.0	71.0	76.0	87.0	1261.0	252.0	174.0	USA
1057	1282	Wallis and Futuna Islands	535.0	778.0	339.0	602.0	638.0	350.0	377.0	225.0	301.0	1189.0	472.0	156.0	USA
1058	1283	Cocos (Keeling) Islands	1441.0	728.0	957.0	933.0	22169.0	6041.0	558.0	779.0	452.0	345.0	83.0	120.0	USA
1059	1284	Tokelau	12987.0	3938.0	4886.0	13422.0	828.0	1346.0	341.0	2474.0	1237.0	18547.0	594.0	87.0	USA

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows